Pandas Profiling Report

Dataset statistics

Number of variables	45
Number of observations	6771
Missing cells	96
Missing cells (%)	< 0.1%
Duplicate rows	191
Duplicate rows (%)	2.8%
Total size in memory	2.3 MiB
Average record size in memory	360.0 B

Variable types

CAT	33
NUM	10
BOOL	2

Warnings

`emd_lable` has constant value "6771"	Constant
`emd_lable2` has constant value "6771"	Constant
Dataset has 191 (2.8%) duplicate rows	Duplicates
`pax_name` has a high cardinality: 6489 distinct values	High cardinality
`pax_passport` has a high cardinality: 6447 distinct values	High cardinality
`pref_line_y3_1` has a high cardinality: 144 distinct values	High cardinality
`pref_line_y3_2` has a high cardinality: 156 distinct values	High cardinality
`pref_line_y3_3` has a high cardinality: 175 distinct values	High cardinality
`pref_line_y3_4` has a high cardinality: 147 distinct values	High cardinality
`pref_line_y3_5` has a high cardinality: 147 distinct values	High cardinality
`pref_city_y3_2` has a high cardinality: 83 distinct values	High cardinality
`pref_city_y3_3` has a high cardinality: 88 distinct values	High cardinality
`flt_cnt_y3` has a high cardinality: 91 distinct values	High cardinality
`avg_dist_cnt_y3` is highly correlated with `avg_dist_cnt_y2`	High correlation
`avg_dist_cnt_y2` is highly correlated with `avg_dist_cnt_y3`	High correlation
`tkt_avg_amt_y3` is highly correlated with `tkt_avg_amt_y2`	High correlation
`tkt_avg_amt_y2` is highly correlated with `tkt_avg_amt_y3`	High correlation
`seg_flight` is highly correlated with `seg_route_to`	High correlation
`seg_route_to` is highly correlated with `seg_flight`	High correlation
`pit_add_chnl_y3` has 96 (1.4%) missing values	Missing
`seat_window_cnt_y3` is highly skewed (γ1 = 25.06414781)	Skewed
`pax_name` is uniformly distributed	Uniform
`pax_passport` is uniformly distributed	Uniform
`seat_walkway_cnt_y3` has 6129 (90.5%) zeros	Zeros
`seat_window_cnt_y3` has 6289 (92.9%) zeros	Zeros
`seat_middle_cnt_y3` has 6353 (93.8%) zeros	Zeros
`avg_dist_cnt_y2` has 6084 (89.9%) zeros	Zeros
`avg_dist_cnt_y3` has 6086 (89.9%) zeros	Zeros
`flt_leg_i_cnt_y3` has 6004 (88.7%) zeros	Zeros
`mdl_mcv` has 6103 (90.1%) zeros	Zeros
`tkt_avg_amt_y1` has 6266 (92.5%) zeros	Zeros
`tkt_avg_amt_y2` has 6128 (90.5%) zeros	Zeros
`tkt_avg_amt_y3` has 6102 (90.1%) zeros	Zeros

Reproduction

Analysis started	2021-03-11 15:50:35.600437
Analysis finished	2021-03-11 15:51:09.173269
Duration	33.57 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

pax_name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	6489
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

884e2983a0740b728adb5aa8be5d5837	5
6e32e5d6e1649f0c73bcc509b5c8e3b9	4
dc81215b4e423a7eae9bbc85bc4ae95b	4
7623c905c7b5f3155e67e1647008c985	4
f1472740493d0096a47c88dd497fb18b	3
Other values (6484)	6751

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
884e2983a0740b728adb5aa8be5d5837	5	0.1%
6e32e5d6e1649f0c73bcc509b5c8e3b9	4	0.1%
dc81215b4e423a7eae9bbc85bc4ae95b	4	0.1%
7623c905c7b5f3155e67e1647008c985	4	0.1%
f1472740493d0096a47c88dd497fb18b	3	< 0.1%
e3133705b3ab483acb909361197e66e8	3	< 0.1%
ecd4cc8f063a1ad4d64ce5db74e84e8c	3	< 0.1%
d933b7ab2b0b2587eba24c5bb9da5ff7	3	< 0.1%
fc4e5102e5da3d80649ac88dd3ef1626	3	< 0.1%
779999ae7a2cf515220842c0d27ca4d9	3	< 0.1%
Other values (6479)	6736	99.5%

Frequencies of value counts

Unique

Unique	6236 ?
Unique (%)	92.1%

Histogram of lengths of the category

Length

Max length	32
Median length	32
Mean length	32
Min length	32

pax_passport
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	6447
Distinct (%)	95.2%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0cf357779a8597a092bdb7e8c4dd0fb9	5
04706e7ca865da4e565d92593968add9	5
a64fed95293b981720bb553074f2fc06	5
eb2cb640b74cf4ff8354d97832969515	4
5fcafded7a9ecb863973769193664b22	4
Other values (6442)	6748

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0cf357779a8597a092bdb7e8c4dd0fb9	5	0.1%
04706e7ca865da4e565d92593968add9	5	0.1%
a64fed95293b981720bb553074f2fc06	5	0.1%
eb2cb640b74cf4ff8354d97832969515	4	0.1%
5fcafded7a9ecb863973769193664b22	4	0.1%
eba97d2a193f832add8c2db9aa23a82f	3	< 0.1%
ee5657503f9828f74bb82e1aeb820b54	3	< 0.1%
d1f777e74758cb7bbaf362c74bfbc9da	3	< 0.1%
dbe116c4a1eb51b0c6cb14e9f62a11e5	3	< 0.1%
fd709cf0b693eb678b6f22b53f64eea8	3	< 0.1%
Other values (6437)	6733	99.4%

Frequencies of value counts

Unique

Unique	6165 ?
Unique (%)	91.1%

Histogram of lengths of the category

Length

Max length	32
Median length	32
Mean length	32
Min length	32

seg_route_to
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

LAX	3493
JFK	3278

Frequencies
Length

Value	Count	Frequency (%)
LAX	3493	51.6%
JFK	3278	48.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

seg_flight
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

AB1008	2028
AB1006	1925
AB1009	1440
AB1010	1353
AB1015	25

Frequencies
Length

Value	Count	Frequency (%)
AB1008	2028	30.0%
AB1006	1925	28.4%
AB1009	1440	21.3%
AB1010	1353	20.0%
AB1015	25	0.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	6
Mean length	6
Min length	6

seg_cabin
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

Y	5845
J	925
F	1

Frequencies
Length

Value	Count	Frequency (%)
Y	5845	86.3%
J	925	13.7%
F	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

emd_lable
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6771

Common Values
Chart

Value	Count	Frequency (%)
0	6771	100.0%

emd_lable2
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6771

Common Values
Chart

Value	Count	Frequency (%)
0	6771	100.0%

gender
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6401
M	188
F	176
U	6

Frequencies
Length

Value	Count	Frequency (%)
0	6401	94.5%
M	188	2.8%
F	176	2.6%
U	6	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

age
Categorical

Distinct	13
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6441
21-30	77
31-40	74
60+	64
51-60	62
Other values (8)	53

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6441	95.1%
21-30	77	1.1%
31-40	74	1.1%
60+	64	0.9%
51-60	62	0.9%
41-50	45	0.7%
11朿0旿2002/2/10	2	< 0.1%
11朿0旿2002/3/21	1	< 0.1%
0-10	1	< 0.1%
11朿0旿2008/5/30	1	< 0.1%
Other values (3)	3	< 0.1%

Frequencies of value counts

Unique

Unique	6 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	15
Median length	1
Mean length	1.185349284
Min length	1

residence_country
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6418
中国	341
美国	10
新加坿0	1
加拿夿0	1

Frequencies
Length

Value	Count	Frequency (%)
0	6418	94.8%
中国	341	5.0%
美国	10	0.1%
新加坿0	1	< 0.1%
加拿夿0	1	< 0.1%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.052724856
Min length	1

nation_name
Categorical

Distinct	21
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6480
美国	157
中国	95
韩国	6
菲律宿0	4
Other values (16)	29

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6480	95.7%
美国	157	2.3%
中国	95	1.4%
韩国	6	0.1%
菲律宿0	4	0.1%
中国台湾	4	0.1%
新加坿0	4	0.1%
泰国	3	< 0.1%
墨西哿0	3	< 0.1%
马来西亚	2	< 0.1%
Other values (11)	13	0.2%

Frequencies of value counts

Unique

Unique	9 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	1
Mean length	1.051247969
Min length	1

province_name
Categorical

Distinct	28
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6677
SH	31
JS	11
ZJ	7
AH	7
Other values (23)	38

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6677	98.6%
SH	31	0.5%
JS	11	0.2%
ZJ	7	0.1%
AH	7	0.1%
NY	5	0.1%
U	3	< 0.1%
S	3	< 0.1%
BJ	3	< 0.1%
HA	2	< 0.1%
Other values (18)	22	0.3%

Frequencies of value counts

Unique

Unique	14 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	12
Median length	1
Mean length	1.02230099
Min length	1

member_level
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6495
STD	237
SILHL	15
GOLHL	12
PLTSL	10

Frequencies
Length

Value	Count	Frequency (%)
0	6495	95.9%
STD	237	3.5%
SILHL	15	0.2%
GOLHL	12	0.2%
PLTSL	10	0.1%
网站	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	5
Median length	1
Mean length	1.092157732
Min length	1

enroll_chnl
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6497
网站	223
销售单使0	16
手机平台	16
其它	8
Other values (2)	11

Frequencies
Length

Value	Count	Frequency (%)
0	6497	96.0%
网站	223	3.3%
销售单使0	16	0.2%
手机平台	16	0.2%
其它	8	0.1%
电话	6	0.1%
移动客舱	5	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	5
Median length	1
Mean length	1.053758677
Min length	1

pref_aircraft_m3_1
Categorical

Distinct	15
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6519
773	185
33L	14
320	9
73E	8
Other values (10)	36

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6519	96.3%
773	185	2.7%
33L	14	0.2%
320	9	0.1%
73E	8	0.1%
73H	7	0.1%
33E	6	0.1%
33H	5	0.1%
738	4	0.1%
73L	4	0.1%
Other values (5)	10	0.1%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.074435091
Min length	1

pref_aircraft_m3_2
Categorical

Distinct	20
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6522
773	86
33L	22
325	17
73E	15
Other values (15)	109

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6522	96.3%
773	86	1.3%
33L	22	0.3%
325	17	0.3%
73E	15	0.2%
738	13	0.2%
33E	12	0.2%
320	12	0.2%
323	11	0.2%
73H	9	0.1%
Other values (10)	52	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.073548959
Min length	1

pref_aircraft_y3_1
Categorical

Distinct	21
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	5924
773	634
320	38
73H	33
325	23
Other values (16)	119

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	5924	87.5%
773	634	9.4%
320	38	0.6%
73H	33	0.5%
325	23	0.3%
33L	19	0.3%
33E	18	0.3%
73E	15	0.2%
333	15	0.2%
33H	11	0.2%
Other values (11)	41	0.6%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.250184611
Min length	1

pref_aircraft_y3_2
Categorical

Distinct	24
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	5932
773	223
325	113
73H	91
320	82
Other values (19)	330

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	5932	87.6%
773	223	3.3%
325	113	1.7%
73H	91	1.3%
320	82	1.2%
33E	51	0.8%
33L	47	0.7%
73E	35	0.5%
333	34	0.5%
33H	30	0.4%
Other values (14)	133	2.0%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.247821592
Min length	1

pref_aircraft_y3_3
Categorical

Distinct	25
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6130
773	167
73H	57
320	55
325	52
Other values (20)	310

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6130	90.5%
773	167	2.5%
73H	57	0.8%
320	55	0.8%
325	52	0.8%
73E	38	0.6%
738	36	0.5%
321	32	0.5%
33E	30	0.4%
33L	27	0.4%
Other values (15)	147	2.2%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.189336878
Min length	1

pref_aircraft_y3_4
Categorical

Distinct	23
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6331
773	156
325	37
320	32
73E	28
Other values (18)	187

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6331	93.5%
773	156	2.3%
325	37	0.5%
320	32	0.5%
73E	28	0.4%
73H	27	0.4%
738	21	0.3%
33H	18	0.3%
33E	18	0.3%
33L	17	0.3%
Other values (13)	86	1.3%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.129966032
Min length	1

pref_aircraft_y3_5
Categorical

Distinct	28
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6452
773	137
325	23
320	16
33E	13
Other values (23)	130

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6452	95.3%
773	137	2.0%
325	23	0.3%
320	16	0.2%
33E	13	0.2%
323	12	0.2%
333	11	0.2%
33H	11	0.2%
73H	11	0.2%
33L	10	0.1%
Other values (18)	75	1.1%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.090680845
Min length	1

pref_line_y3_1
Categorical

HIGH CARDINALITY

Distinct	144
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6040
JFK-PVG	165
LAX-PVG	112
PVG-JFK	58
PVG-LAX	49
Other values (139)	347

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6040	89.2%
JFK-PVG	165	2.4%
LAX-PVG	112	1.7%
PVG-JFK	58	0.9%
PVG-LAX	49	0.7%
PVG-BKK	25	0.4%
SIN-PVG	25	0.4%
PVG-ICN	19	0.3%
SFO-PVG	13	0.2%
PVG-WNZ	10	0.1%
Other values (134)	255	3.8%

Frequencies of value counts

Unique

Unique	73 ?
Unique (%)	1.1%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.647762517
Min length	1

pref_line_y3_2
Categorical

HIGH CARDINALITY

Distinct	156
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6048
PVG-JFK	132
JFK-PVG	91
PVG-LAX	85
LAX-PVG	83
Other values (151)	332

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6048	89.3%
PVG-JFK	132	1.9%
JFK-PVG	91	1.3%
PVG-LAX	85	1.3%
LAX-PVG	83	1.2%
BKK-PVG	16	0.2%
PVG-SFO	11	0.2%
PVG-HKG	10	0.1%
PVG-BKK	9	0.1%
PVG-ORD	7	0.1%
Other values (146)	279	4.1%

Frequencies of value counts

Unique

Unique	78 ?
Unique (%)	1.2%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.64067346
Min length	1

pref_line_y3_3
Categorical

HIGH CARDINALITY

Distinct	175
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6205
PVG-LAX	73
PVG-JFK	58
JFK-PVG	42
LAX-PVG	33
Other values (170)	360

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6205	91.6%
PVG-LAX	73	1.1%
PVG-JFK	58	0.9%
JFK-PVG	42	0.6%
LAX-PVG	33	0.5%
PVG-HKG	9	0.1%
PVG-BKK	9	0.1%
SIN-PVG	8	0.1%
WNZ-PVG	8	0.1%
CAN-PVG	7	0.1%
Other values (165)	319	4.7%

Frequencies of value counts

Unique

Unique	84 ?
Unique (%)	1.2%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.501550731
Min length	1

pref_line_y3_4
Categorical

HIGH CARDINALITY

Distinct	147
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6302
PVG-JFK	49
PVG-LAX	34
LAX-PVG	26
BKK-PVG	20
Other values (142)	340

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6302	93.1%
PVG-JFK	49	0.7%
PVG-LAX	34	0.5%
LAX-PVG	26	0.4%
BKK-PVG	20	0.3%
JFK-PVG	18	0.3%
ICN-PVG	16	0.2%
PVG-SIN	13	0.2%
KUL-PVG	11	0.2%
FOC-PVG	9	0.1%
Other values (137)	273	4.0%

Frequencies of value counts

Unique

Unique	69 ?
Unique (%)	1.0%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.41382366
Min length	1

pref_line_y3_5
Categorical

HIGH CARDINALITY

Distinct	147
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6494
PVG	14
PVG-JFK	13
LAX-PVG	12
JFK-PVG	12
Other values (142)	226

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6494	95.9%
PVG	14	0.2%
PVG-JFK	13	0.2%
LAX-PVG	12	0.2%
JFK-PVG	12	0.2%
PVG-LAX	11	0.2%
JFK	5	0.1%
BKK-PVG	5	0.1%
KIX-PVG	5	0.1%
ORD-PVG	4	0.1%
Other values (137)	196	2.9%

Frequencies of value counts

Unique

Unique	93 ?
Unique (%)	1.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.228326687
Min length	1

pref_city_y3_1
Categorical

Distinct	49
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	5923
PVG	615
SHA	50
JFK	41
LAX	16
Other values (44)	126

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	5923	87.5%
PVG	615	9.1%
SHA	50	0.7%
JFK	41	0.6%
LAX	16	0.2%
SIN	12	0.2%
SZX	8	0.1%
TAO	7	0.1%
TYN	7	0.1%
WUH	7	0.1%
Other values (39)	85	1.3%

Frequencies of value counts

Unique

Unique	21 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.250479988
Min length	1

pref_city_y3_2
Categorical

HIGH CARDINALITY

Distinct	83
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	5938
JFK	193
LAX	151
PVG	143
SHA	33
Other values (78)	313

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	5938	87.7%
JFK	193	2.9%
LAX	151	2.2%
PVG	143	2.1%
SHA	33	0.5%
SIN	30	0.4%
PEK	14	0.2%
PUS	12	0.2%
ICN	11	0.2%
NKG	11	0.2%
Other values (73)	235	3.5%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.246049328
Min length	1

pref_city_y3_3
Categorical

HIGH CARDINALITY

Distinct	88
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6151
JFK	101
LAX	94
PVG	47
ICN	34
Other values (83)	344

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6151	90.8%
JFK	101	1.5%
LAX	94	1.4%
PVG	47	0.7%
ICN	34	0.5%
SHA	26	0.4%
HKG	21	0.3%
PEK	19	0.3%
BKK	18	0.3%
XIY	15	0.2%
Other values (78)	245	3.6%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.183133954
Min length	1

pref_dest_city_y1
Categorical

Distinct	46
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6254
Shanghai	251
New York	130
Los Angeles	57
Beijing	9
Other values (41)	70

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6254	92.4%
Shanghai	251	3.7%
New York	130	1.9%
Los Angeles	57	0.8%
Beijing	9	0.1%
TAIPEI	6	0.1%
BANGKOK	4	0.1%
Nanjing	3	< 0.1%
Seoul	3	< 0.1%
Yantai	3	< 0.1%
Other values (36)	51	0.8%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	22
Median length	1
Mean length	1.554127898
Min length	1

pref_dest_city_y2
Categorical

Distinct	45
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6116
Shanghai	400
New York	110
Los Angeles	61
Beijing	8
Other values (40)	76

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6116	90.3%
Shanghai	400	5.9%
New York	110	1.6%
Los Angeles	61	0.9%
Beijing	8	0.1%
TAIPEI	6	0.1%
Fuzhou	5	0.1%
BANGKOK	4	0.1%
SAN FRANCISICO	4	0.1%
Xi'an	4	0.1%
Other values (35)	53	0.8%

Frequencies of value counts

Unique

Unique	21 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	22
Median length	1
Mean length	1.703588835
Min length	1

pref_dest_city_y3
Categorical

Distinct	40
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6087
Shanghai	436
New York	99
Los Angeles	54
Beijing	9
Other values (35)	86

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6087	89.9%
Shanghai	436	6.4%
New York	99	1.5%
Los Angeles	54	0.8%
Beijing	9	0.1%
TAIPEI	7	0.1%
Xi'an	6	0.1%
Guangzhou	5	0.1%
Nanjing	5	0.1%
SAN FRANCISICO	4	0.1%
Other values (30)	59	0.9%

Frequencies of value counts

Unique

Unique	13 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	22
Median length	1
Mean length	1.734012701
Min length	1

pit_add_chnl_y3
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	96
Missing (%)	1.4%
Memory size	52.9 KiB

0	6502
航空累积	168
非航累积	5

Frequencies
Length

Value	Count	Frequency (%)
0	6502	96.0%
航空累积	168	2.5%
非航累积	5	0.1%
(Missing)	96	1.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.105006646
Min length	1

seat_walkway_cnt_y3
Real number (ℝ_≥0)

ZEROS

Distinct	30
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4339093192
Minimum	0
Maximum	89
Zeros	6129
Zeros (%)	90.5%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	89
Range	89
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.563151403
Coefficient of variation (CV)	5.907113053
Kurtosis	531.6123631
Mean	0.4339093192
Median Absolute Deviation (MAD)	0
Skewness	18.98094684
Sum	2938
Variance	6.569745114
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	6129	90.5%
1	133	2.0%
2	129	1.9%
3	113	1.7%
4	69	1.0%
5	60	0.9%
6	41	0.6%
7	19	0.3%
8	19	0.3%
9	17	0.3%
Other values (20)	42	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6129	90.5%
1	133	2.0%
2	129	1.9%
3	113	1.7%
4	69	1.0%

Value	Count	Frequency (%)
89	2	< 0.1%
58	1	< 0.1%
54	1	< 0.1%
48	1	< 0.1%
47	1	< 0.1%

seat_window_cnt_y3
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	23
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2668734308
Minimum	0
Maximum	92
Zeros	6289
Zeros (%)	92.9%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	92
Range	92
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.83140016
Coefficient of variation (CV)	6.862429708
Kurtosis	1039.551104
Mean	0.2668734308
Median Absolute Deviation (MAD)	0
Skewness	25.06414781
Sum	1807
Variance	3.354026545
Monotocity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	6289	92.9%
1	152	2.2%
2	113	1.7%
3	68	1.0%
4	50	0.7%
5	22	0.3%
8	13	0.2%
6	13	0.2%
7	10	0.1%
9	8	0.1%
Other values (13)	33	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6289	92.9%
1	152	2.2%
2	113	1.7%
3	68	1.0%
4	50	0.7%

Value	Count	Frequency (%)
92	1	< 0.1%
48	1	< 0.1%
36	1	< 0.1%
24	1	< 0.1%
23	1	< 0.1%

seat_middle_cnt_y3
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1379412199
Minimum	0
Maximum	16
Zeros	6353
Zeros (%)	93.8%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	16
Range	16
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7058693479
Coefficient of variation (CV)	5.117174898
Kurtosis	128.3190002
Mean	0.1379412199
Median Absolute Deviation (MAD)	0
Skewness	9.177940107
Sum	934
Variance	0.4982515363
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	6353	93.8%
1	174	2.6%
2	125	1.8%
3	60	0.9%
4	31	0.5%
6	10	0.1%
5	9	0.1%
13	4	0.1%
9	2	< 0.1%
7	1	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6353	93.8%
1	174	2.6%
2	125	1.8%
3	60	0.9%
4	31	0.5%

Value	Count	Frequency (%)
16	1	< 0.1%
13	4	0.1%
9	2	< 0.1%
8	1	< 0.1%
7	1	< 0.1%

avg_dist_cnt_y2
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	513
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	759.1510111
Minimum	0
Maximum	14363.66667
Zeros	6084
Zeros (%)	89.9%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7075
Maximum	14363.66667
Range	14363.66667
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2492.929081
Coefficient of variation (CV)	3.283838189
Kurtosis	11.38700788
Mean	759.1510111
Median Absolute Deviation (MAD)	0
Skewness	3.450420344
Sum	5140211.496
Variance	6214695.405
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6084	89.9%
13239	38	0.6%
10837.5	13	0.2%
10867	9	0.1%
5975.5	8	0.1%
13390	7	0.1%
7176.25	6	0.1%
13188.66667	5	0.1%
13088	5	0.1%
3019	5	0.1%
Other values (503)	591	8.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6084	89.9%
407	1	< 0.1%
490	1	< 0.1%
490.6666667	1	< 0.1%
675	1	< 0.1%

Value	Count	Frequency (%)
14363.66667	1	< 0.1%
14363.5	2	< 0.1%
13390	7	0.1%
13314.5	1	< 0.1%
13289.33333	1	< 0.1%

avg_dist_cnt_y3
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	540
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	745.2562932
Minimum	0
Maximum	14363.66667
Zeros	6086
Zeros (%)	89.9%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7075
Maximum	14363.66667
Range	14363.66667
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2452.161296
Coefficient of variation (CV)	3.290359731
Kurtosis	11.42732767
Mean	745.2562932
Median Absolute Deviation (MAD)	0
Skewness	3.454084287
Sum	5046130.361
Variance	6013095.023
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6086	89.9%
13239	23	0.3%
10837.5	13	0.2%
13103	9	0.1%
12967	8	0.1%
3019	6	0.1%
7176.25	6	0.1%
10867	5	0.1%
13188.66667	4	0.1%
13390	4	0.1%
Other values (530)	607	9.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6086	89.9%
1	1	< 0.1%
407	1	< 0.1%
490	1	< 0.1%
490.6666667	1	< 0.1%

Value	Count	Frequency (%)
14363.66667	1	< 0.1%
14363.5	2	< 0.1%
13390	4	0.1%
13289.33333	1	< 0.1%
13269.2	1	< 0.1%

flt_cnt_y3
Categorical

HIGH CARDINALITY

Distinct	91
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6027
4	131
2	83
6	81
3	74
Other values (86)	375

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6027	89.0%
4	131	1.9%
2	83	1.2%
6	81	1.2%
3	74	1.1%
8	56	0.8%
5	48	0.7%
7	31	0.5%
1	29	0.4%
10	23	0.3%
Other values (81)	188	2.8%

Frequencies of value counts

Unique

Unique	55 ?
Unique (%)	0.8%

Histogram of lengths of the category

Length

Max length	10
Median length	1
Mean length	1.090680845
Min length	1

flt_leg_i_cnt_y3
Real number (ℝ_≥0)

ZEROS

Distinct	29
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.6192586029
Minimum	0
Maximum	67
Zeros	6004
Zeros (%)	88.7%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4
Maximum	67
Range	67
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.598899002
Coefficient of variation (CV)	4.196791115
Kurtosis	181.233607
Mean	0.6192586029
Median Absolute Deviation (MAD)	0
Skewness	10.24146107
Sum	4193
Variance	6.754276023
Monotocity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	6004	88.7%
4	156	2.3%
2	132	1.9%
3	93	1.4%
1	76	1.1%
6	65	1.0%
5	53	0.8%
8	44	0.6%
7	31	0.5%
9	25	0.4%
Other values (19)	92	1.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6004	88.7%
1	76	1.1%
2	132	1.9%
3	93	1.4%
4	156	2.3%

Value	Count	Frequency (%)
67	1	< 0.1%
61	2	< 0.1%
41	1	< 0.1%
32	2	< 0.1%
31	1	< 0.1%

flt_leg_d_cnt_y3
Categorical

Distinct	40
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	52.9 KiB

0	6421
2	69
1	69
3	48
4	32
Other values (35)	132

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	6421	94.8%
2	69	1.0%
1	69	1.0%
3	48	0.7%
4	32	0.5%
{'1': 0, '2': 0, '3': 0, '4': 0, '5': 0, '6': 0}	26	0.4%
5	17	0.3%
6	16	0.2%
7	14	0.2%
9	9	0.1%
Other values (30)	50	0.7%

Frequencies of value counts

Unique

Unique	20 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	48
Median length	1
Mean length	1.336434795
Min length	1

mdl_mcv
Real number (ℝ_≥0)

ZEROS

Distinct	25
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.064829212
Minimum	0
Maximum	300
Zeros	6103
Zeros (%)	90.1%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	70
Maximum	300
Range	300
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	30.7266159
Coefficient of variation (CV)	3.809952461
Kurtosis	24.75570153
Mean	8.064829212
Median Absolute Deviation (MAD)	0
Skewness	4.70023363
Sum	54606.95859
Variance	944.1249249
Monotocity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	6103	90.1%
20	123	1.8%
50	66	1.0%
40	55	0.8%
120	55	0.8%
70	42	0.6%
130	32	0.5%
100	32	0.5%
10	31	0.5%
140	27	0.4%
Other values (15)	205	3.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6103	90.1%
10	31	0.5%
20	123	1.8%
28.195679	1	< 0.1%
29.38145729	2	< 0.1%

Value	Count	Frequency (%)
300	4	0.1%
250	11	0.2%
220	11	0.2%
210	5	0.1%
200	8	0.1%

tkt_avg_amt_y1
Real number (ℝ_≥0)

ZEROS

Distinct	461
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	102.2141837
Minimum	0
Maximum	13654.92
Zeros	6266
Zeros (%)	92.5%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	417.9521428
Maximum	13654.92
Range	13654.92
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	591.2974563
Coefficient of variation (CV)	5.78488655
Kurtosis	137.4922901
Mean	102.2141837
Median Absolute Deviation (MAD)	0
Skewness	10.03331538
Sum	692092.2376
Variance	349632.6818
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6266	92.5%
2493.655	3	< 0.1%
850.47375	3	< 0.1%
5320.203684	3	< 0.1%
1121.289474	3	< 0.1%
257.4011111	3	< 0.1%
213.06125	2	< 0.1%
733.285	2	< 0.1%
520.6	2	< 0.1%
3336.295	2	< 0.1%
Other values (451)	482	7.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6266	92.5%
0.0025	1	< 0.1%
14.585	1	< 0.1%
15.064	1	< 0.1%
15.11170732	1	< 0.1%

Value	Count	Frequency (%)
13654.92	1	< 0.1%
11712.67667	1	< 0.1%
9937.415	1	< 0.1%
9079.455	1	< 0.1%
9020.44	1	< 0.1%

tkt_avg_amt_y2
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	593
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	182.3033287
Minimum	0
Maximum	21898.53
Zeros	6128
Zeros (%)	90.5%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	995.95875
Maximum	21898.53
Range	21898.53
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	920.5085624
Coefficient of variation (CV)	5.049323943
Kurtosis	120.6585729
Mean	182.3033287
Median Absolute Deviation (MAD)	0
Skewness	9.176780875
Sum	1234375.838
Variance	847336.0134
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6128	90.5%
2267.455789	3	< 0.1%
1589.5025	3	< 0.1%
2790.383333	3	< 0.1%
636.3088889	3	< 0.1%
5320.203684	3	< 0.1%
1249.099	2	< 0.1%
830.6375	2	< 0.1%
2579.4495	2	< 0.1%
525.352	2	< 0.1%
Other values (583)	620	9.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6128	90.5%
15.064	1	< 0.1%
25.54	1	< 0.1%
43.4675	1	< 0.1%
72.575	1	< 0.1%

Value	Count	Frequency (%)
21898.53	1	< 0.1%
16115.70333	1	< 0.1%
14113.38	1	< 0.1%
13654.92	1	< 0.1%
13598.805	1	< 0.1%

tkt_avg_amt_y3
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	618
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	208.1421056
Minimum	0
Maximum	21898.53
Zeros	6102
Zeros (%)	90.1%
Memory size	52.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1129.823333
Maximum	21898.53
Range	21898.53
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1012.999276
Coefficient of variation (CV)	4.866863785
Kurtosis	99.24700009
Mean	208.1421056
Median Absolute Deviation (MAD)	0
Skewness	8.509208362
Sum	1409330.197
Variance	1026167.533
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6102	90.1%
5320.203684	3	< 0.1%
686.3827778	3	< 0.1%
2790.383333	3	< 0.1%
1773.83	3	< 0.1%
3489.626842	3	< 0.1%
2158.444444	2	< 0.1%
936.2883333	2	< 0.1%
1257.78	2	< 0.1%
826.545	2	< 0.1%
Other values (608)	646	9.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6102	90.1%
15.064	1	< 0.1%
43.4675	1	< 0.1%
56.95	1	< 0.1%
107.278	1	< 0.1%

Value	Count	Frequency (%)
21898.53	1	< 0.1%
16115.70333	1	< 0.1%
14113.38	1	< 0.1%
13862.975	1	< 0.1%
13654.92	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	pax_name	pax_passport	seg_route_to	seg_flight	seg_cabin	gender	age	residence_country	nation_name	province_name	member_level	enroll_chnl	pref_aircraft_y3_1	pref_aircraft_y3_2	pref_line_y3_1	pref_line_y3_2	pref_line_y3_3	pref_line_y3_4	pref_line_y3_5	pref_city_y3_1	pref_city_y3_2	pref_city_y3_3	pref_dest_city_y1	pref_dest_city_y2	pref_dest_city_y3	pit_add_chnl_y3	seat_walkway_cnt_y3	seat_window_cnt_y3	seat_middle_cnt_y3	avg_dist_cnt_y2	avg_dist_cnt_y3	flt_cnt_y3	flt_leg_i_cnt_y3	flt_leg_d_cnt_y3	mdl_mcv	tkt_avg_amt_y1	tkt_avg_amt_y2	tkt_avg_amt_y3
0	21f0b1c838160ac26cb2c57660bc3fd5	83685748783343bccba7a8c3c6a5c813	JFK	AB1010	Y	0	51-60	0	美国	SH	STD	其它	0	0	CAN-SHA	YVR-PVG	SHA-CAN	PVG-JFK	PVG-YVR	0	0	0	New York	Shanghai	Shanghai	0	0	1	0	8636.8	5658.923077	13	0	7	130.0	282.256923	524.7500	920.134615
1	21e0621a85f6db6139ff7cf2d53b4e5d	38da646d04551c8ad4652ab9d8a944b0	LAX	AB1008	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0	0.000000	0	0	0	0.0	0.000000	0.0000	0.000000
2	197b215b23a93b19f391c422eb27f310	d9ac3f8a7ae010694f2391558a24129c	JFK	AB1010	Y	0	0	0	0	0	0	0	0	0	JFK-PVG	PVG-KUL	0	0	0	0	0	0	0	KUALA LUMPUR	KUALA LUMPUR	0	0	2	0	8749.0	8749.000000	2	0	0	10.0	0.000000	364.4250	364.425000
3	92b435f20c6ce2fd5acef7b6ff49b6d0	1ffdb2de8c1ef1c7176f89cbf567ab10	LAX	AB1009	Y	F	0	中国	0	0	0	0	773	33E	0	0	0	0	0	PVG	SIN	LAX	0	0	0	0	4	0	0	0.0	0.000000	0	4	0	0.0	0.000000	0.0000	0.000000
4	a38ac8bfe0feb14c0469e2917bc74a05	231a4d2ca500b1bcfb0abcd0247057d0	JFK	AB1006	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0	0.000000	0	0	0	0.0	0.000000	0.0000	0.000000
5	6f514830842c0132578432753b701d24	eee37b2637ec23d01f92432b2063bf05	JFK	AB1010	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0	0.000000	0	0	0	0.0	0.000000	0.0000	0.000000
6	65e4bbac21f671d39faf6c76c0a9285e	69615860c506fc4fdf5251458424e2f9	JFK	AB1006	Y	0	21-30	0	泰国	0	STD	网站	0	0	PVG-BKK	JFK-PVG	PVG-JFK	BKK-PVG	0	0	0	0	0	Shanghai	Shanghai	0	0	4	0	8168.0	8168.000000	4	0	0	30.0	0.000000	529.4950	529.495000
7	47ccbe82525a0dbb19bf17487d4b5b5a	53c6b18e06dec04b82e88c5e3a73c91c	JFK	AB1006	Y	0	21-30	0	美国	0	STD	网站	0	0	JFK-PVG	HND-PVG	PVG-HND	0	0	0	0	0	0	0	Shanghai	0	0	0	0	1740.0	5493.333333	3	0	0	20.0	0.000000	0.0000	579.643333
8	b25c0d141bf303ad1cb3051f5bed8729	6016a0a65aecb2088129b99d12ecc5b9	LAX	AB1008	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0	0.000000	0	0	0	0.0	0.000000	0.0000	0.000000
9	8990a44ca0a7448b1dae1f2bb88faef7	b580dd1d656b12eda4a8a26007327ccb	LAX	AB1009	Y	F	21-30	中国	美国	JS	STD	网站	773	319	PVG-LAX	SFO-PVG	NKG-PVG	0	0	PVG	LAX	0	0	Los Angeles	Los Angeles	航空累积	2	0	2	10929.0	8234.750000	4	3	1	50.0	0.000000	953.4575	1396.190000

Last rows

	pax_name	pax_passport	seg_route_to	seg_flight	seg_cabin
6761	cb3bcf8538eb2e5b080984f75aef3c24	d2716cfab47e5f18388ef8b969038df7	JFK	AB1010	Y
6762	a8d291065d09b799ee32efb7e0e28d01	dda7c0f122e1819b2b996ace36f58a37	LAX	AB1009	Y
6763	dd3213d717570f08b0279c3f8be1c2ab	02cded3cd573a95904acd6b427757447	LAX	AB1008	Y
6764	b4bd21f8e42a897a727643b41bf663a8	12f1872669e1d4bfa5367de9e7ace695	LAX	AB1009	Y
6765	8f1f3dc11de90cdd555a7d30c62d7343	8a8a0ee98e173da437dec2b87447634d	JFK	AB1006	Y
6766	d6364954adcfbd58d8beebd686a9fbdc	931a5e027bd353621276e0dd895e1891	LAX	AB1008	J
6767	150b405be4282907eb7e87f992856ea1	1a17953ed59e6239239d4dda9155c2b8	LAX	AB1008	Y
6768	33b02fadd0d05938b8cc3dfbc735fd10	e33a28587bd6a9d49506dfde4fc4cd49	JFK	AB1006	Y
6769	29cb3dea4ecce778096484ff2e097f5b	c12d4deab331a243c15617501d24851e	JFK	AB1010	Y
6770	ded3592dc9da0c1ace02ed8e361efc23	c9e0dced06ef5c9037bc3a0315a4704f	LAX	AB1008	Y

Most frequent

	pax_name	pax_passport	seg_route_to	seg_flight	seg_cabin	gender	age	residence_country	nation_name	province_name	member_level	enroll_chnl	pref_aircraft_m3_1	pref_aircraft_m3_2	pref_aircraft_y3_1	pref_aircraft_y3_2	pref_aircraft_y3_3	pref_aircraft_y3_4	pref_aircraft_y3_5	pref_line_y3_1	pref_line_y3_2	pref_line_y3_3	pref_line_y3_4	pref_line_y3_5	pref_city_y3_1	pref_city_y3_2	pref_city_y3_3	pref_dest_city_y1	pref_dest_city_y2	pref_dest_city_y3	pit_add_chnl_y3	seat_walkway_cnt_y3	seat_window_cnt_y3	seat_middle_cnt_y3	avg_dist_cnt_y2	avg_dist_cnt_y3	flt_cnt_y3	flt_leg_i_cnt_y3	flt_leg_d_cnt_y3	mdl_mcv	tkt_avg_amt_y1	tkt_avg_amt_y2	tkt_avg_amt_y3	count
84	884e2983a0740b728adb5aa8be5d5837	04706e7ca865da4e565d92593968add9	JFK	AB1006	J	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	5
74	7623c905c7b5f3155e67e1647008c985	5fcafded7a9ecb863973769193664b22	LAX	AB1008	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	4
58	5bfbe93dce75d9c22c47e87bd9359b39	1b97eba650abecbf9d9eecdee912a370	LAX	AB1008	J	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	3
68	6c6dce7c8c665df07ccc3d01ff2b5f86	eba97d2a193f832add8c2db9aa23a82f	LAX	AB1008	Y	F	0	中国	0	0	0	0	773	73V	773	73E	325	320	76E	0	0	0	0	0	SZX	SHA	PVG	0	0	0	航空累积	21	0	5	0.000	0.000000	0	15	0	0.0	0.000000	0.000000	0.000000	3
76	779999ae7a2cf515220842c0d27ca4d9	b54899ca796ba16a928dd77b6c65da5e	LAX	AB1009	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	3
87	8b1310e1ad2ed70c1fef327369eb29d4	0cf357779a8597a092bdb7e8c4dd0fb9	LAX	AB1009	J	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	3
102	9c7c4b0a727a1abf489877aecea3c8e6	4310eb2e24571f724e6227d9196cefb0	JFK	AB1006	Y	M	31-40	中国	美国	0	STD	网站	773	773	773	773	773	773	773	JFK-PVG	PVG-JFK	0	0	0	PVG	JFK	0	New York	New York	New York	航空累积	5	0	1	13239.000	13239.000000	6	6	0	120.0	2493.655000	2790.383333	2790.383333	3
122	c1a28b8b969ecdd74a7b6b01af76c71e	72f0bf3f0d855bfa95dabc3e8e435c4f	LAX	AB1008	J	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	3
125	c44e7e31e3f4562f639ca18a6f3cde06	dbe116c4a1eb51b0c6cb14e9f62a11e5	JFK	AB1006	Y	0	60+	0	中国	NY	STD	网站	0	0	0	0	0	0	0	PVG-JFK	JFK-PVG	PVG-CGO	CGO-PVG	CGO-SHA	0	0	0	Shanghai	Shanghai	Shanghai	0	0	4	0	6998.875	6992.722222	18	0	9	220.0	257.401111	636.308889	686.382778	3
145	d933b7ab2b0b2587eba24c5bb9da5ff7	80d2f5950df6944e6cb23255e6daa1ce	LAX	AB1009	Y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000000	0	0	0	0.0	0.000000	0.000000	0.000000	3

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent